A Lookup Query is a definition that defines a query that can be used to control the lookup values listed for fields in data management queries. An administration page has been added to enable the management of Lookup Queries.
Lookup Queries pages are used to define custom lookups that will be available to be assigned to data management queries fields.
In the above example a query has been generated over the Locations table to only output locations of type Stockpile.
The table below list the fields for Lookup queries.
| Fields | Description |
|---|---|
|
Id |
The unique identifier of the lookup query, which is automatically generated when a record is created and cannot be edited. |
|
Code |
The code of the lookup query, which will be displayed as an option on the Lookup Value column for data management quieries fields. |
|
Description |
A description of the lookup query. |
|
Lookup Query |
Paste the query to be used to generate the lookup values here. Note: Create the query using query builder, copy it to the clipboard then paste here. |
Note: Field labels highlighted as bold must have a value entered or selected as they are mandatory.
Refer to the Managing Administration Definition Types topic for information on how to manage the Lookup Queries - Administration definitions.
The Lookup Queries table can be accessed in Query Builder from the Setup > Administration menu.
